Round 1 - Coding

🔹 You have a machine with 4 buttons - 1st button can increase the time by 60 minutes, 2nd button can increase the time by 15 minutes, 3rd button can increase the time by 5 minutes and 4th button can increase the time by 1 minute. As a input you will be given input timestamp in the format HH:MM and current timestamp will be displayed on the machine, Calculate the minimum number of key presses required to get input time HH:MM from current timestamp

Round 2 - Coding

🔹 You will be given input timestamps in the format HH:MM where 0<=H<=9, 0<=M<=9. Write a code to find next minimum timestamp value which can be generated using same digits of HH:MM

Round 3 - Technical

🔹 Apache Spark related questions - Fundamentals, OOM scenarios in Spark and how to fix them, how to optimize an Spark application, Optimized joins in Spark

🔹 Solve SQL queries for the employee & manager dataset

🔹 Coding question to find the frequency of each character given in a string

Round 4 - Application Design & Domain Knowledge

🔹 Design an Uber kind of application and it’s Data Warehouse

Round 5 - System Integration Knowledge

🔹 Project deep dive discussion based on my resume

🔹 Design real time data ingestion pipeline which will consume data from IoT device and after processing data will be ingested in the realtime in BigQuery

Round 6 - Googliness

🔹 Behavioural and team fitment kind of questions

🔹 Questions around Google’s leadership principles

🔹 Assume you are working for a startup, the CTO has left the company and now you have been given that responsibility. What kind of changes will you bring as per Employee and Employer?

🔹 Let’s say you and your team member are working on a project, your teammate was assigned to come up with a design. You have to review his design and provide your inputs, somehow your teammate is very rigid about his architecture design and not listening to any feedback. Then how would you handle this situation and discuss these things with your manager?

Round 7 - Hiring Manager

🔹 Discussion around my past experience and projects, some resume based questions

🔹 My experience of working on challenging projects and how did I deal with those challenges